<%-- 
    Document   : Top5Member
    Created on : Oct 30, 2009, 9:18:31 PM
    Author     : Phong
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <%@page import="java.sql.*"  %>
        <jsp:useBean id="mem" class="DAOClass.Members" scope="request" />
        <%
            ResultSet rs1 = null;
        %>
        <form name="vote" action="#" method="post">
            <table border="1" width="240" style="border:solid 1px;border-collapse:collapse " >
                <thead>
                    <tr>
                        <th>User Name</th>
                        <th>Mark</th>
                    </tr>
                </thead>
                <%
                rs1 = mem.selectTopMember();
                while (rs1.next()) {
                %>
                <tbody>
                    <tr>
                        <td valign="top"><%=rs1.getString("UserName")%></td>
                        <td valign="top"><%=rs1.getInt("Mark")%></td>
                    </tr>
                </tbody>
            </table>

            <%            }
            %>
        </form>
    </body>
</html>
